You are here: Main Menu > I. Interface Menu > 7. External System > C. ESI Posted Transactions List

ESI Posted Transactions List

The ESI Posted Transaction List function creates an export file on the details posted to a locked accounting period for the accounting period and year selected.

1. Follow the common External System Interface (ESI) overview and instructions found in the ESI menu overview.

2. At the Period field, enter the accounting period for the ESI posted transactions list file.

Note: The report will not print if there are no locked periods found. If there are no locked accounting periods the following message will display: "No Locked Periods Found!!! Space bar to continue." Press the space bar to continue. If the period selected is not locked the following message will display: "Not a locked period!!! Space bar to continue." The period must be locked in Accounting Periods.

3. At the Year field, enter the year for the file.

If the file name and type selected already exist, the following message will display: "Warning: File already exists!!! Continue? No/Yes."

Select no to return to the command options.
Select yes to create a new file with the same name that already exists.

4. The following message will display: "Print report? No/Yes."

Select no to generate the export file without a printed detail report.
Select yes to create the file with a printed detail report. Command options will appear allowing you to print or choose from a set of other print options.

5. The following message will display: "Create a delimited ASC file? No/Yes?"

Select no to create a DBF file only.
Select yes to create a DBF file and an ASC file.

Make the appropriate selection.

Two DBF files will be created PTPPYYYY.dbf and PT_Last.dbf in the Shared \NetYield\Data\Company Name\ESI Outbox folder. The PTPPYYYY.dbf file is the ESI Posted Transaction List file for the selected period and year with PPYYYY equal to the period and year selected. The PT_Last.dbf is a copy of the current file. If an ASC file was created the name will be PTPPYYYY.asc and will be found in the Shared \NetYield\Data\Company Name\ESI Outbox folder.

The following report fields will print:

Jrnl Type – The journal entry type – see Post Batches for more information.
Source Type – The journal entry transaction type – see Post Batches for more information.
Acct – The general ledger account number
Sub – The cost center
CRS Acct – N/A
Ref No – The transaction reference number
Amount – The transaction amount
CR/DB – The transaction
- CR – Credit balance
- DR – Debit balance
Tran Date – The transaction date
Transaction Description – The ledger transaction description for the transaction.

The following fields will be exported from the system:

Field Name	Description	Type
LICNUMBER	The Net•Yield license number	C 4
PERIOD	The accounting period.	C 2
YEAR	The accounting year	C 4
JOURNAL	The journal entry type – see Post Batches for more information	C 2
SOURCE	The journal entry transaction type – see Post Batches for more information.	C 2
ACCOUNT	The account number for the transaction	C 4
SUB_ACCT	The cost center for the transaction	C 6
CRS_ACCT	N/A	C 6
REFERENCE	The transaction reference number	C 6
AMOUNT	The journal entry amount	N 12, 2
CR_DB	The credit or debit for the journal entry	C 1
DATE	The date of the transaction	D 8
DESC	The transaction description	C 30

Security Required : Ledger - Ledger Reports